home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / subsystems.sql < prev    next >
Text File  |  2000-05-12  |  830b  |  25 lines
  1. /* RCSVER $Id: subsystems.sql,v 1.3 1999-03-19 09:50:00-06 randy CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        subsystems.sql
  6. * Date:        12/28/1998
  7. * memo:        Randy Wood
  8. * Description:    Create the subsystems.table. This table contains definitions
  9. *        of all valid subsystems.
  10. * Changes:
  11. ************************************************************************* */
  12. /* SUBSYSTEMS
  13.     1    Central Host Computer
  14.     2    Moneyroom Computer
  15.     3    Garage Revenue Station
  16.     4    Farebox
  17. */
  18. CREATE TABLE subsystems
  19. (
  20.     id        NUMBER(38),    /* ID of this subsystem */
  21.     descr        VARCHAR2(30),    /* Description of subsystem */
  22.     useCharPW    NUMBER(1),    /* Use a character user ID? */
  23.     CONSTRAINT pk_subsystems PRIMARY KEY (id)
  24. );
  25.